#include <iostream>
#include <string>

using namespace std;

int main()
{
	string sqlStatement     =  "SELECT sp46212.intersection.ideptnum, sp46212.department.deptname,"
                                + "        sp46212.department.deptlocation, sp46212.intersection.ifacnum,"
                                + "        sp46212.faculty.facname, sp46212.faculty.facrank, sp46212.faculty.facyearstart"
			        + "FROM    sp46212.department"
			        + "JOIN    sp46212.intersection"
			        + "ON      sp46212.department.deptnum = sp46212.intersection.ideptnum"
			        + "JOIN    sp46212.faculty"
			        + "ON      sp46212.intersection.deptnum = sp46212.faculty.facnum"
			        + "WHERE   sp46212.department.deptnum = 02";
									
        cout << "Query is:  " << sqlStatement << endl;

	return 0;
}
